1.Explain oracle architecture

2. DDl and DML

3.Difference between cursor and ref cursor

4.write  a program using cursor

5.types of exception

6. Name some predefined exceptions

7. Write a program using user defined exceptions

8. Datatypes in oracle

9. Trigger

10. Explain ref cursor

11. Performance tuning

They are asking to write procedures by giving scenarios.